/*
 * @(#) IATConstants.java 2013-5-28 下午2:39:33
 *
 * Copyright 2013 Rockwell Automation, Inc. All rights reserved.
 * Rockwell Automation PROPRIETARY/CONFIDENTIAL. Use is subject to license terms.
 */package com.osi.mes.constants;

 /**
  * AT表定义 
  * 表名使用 AT_TABLE_<TABLENAME> 
  * 列名使用 AT_COLUMN_<TABLENAME>_<COLUMN_NAME>
  * 
  * @author Nemo, 2013-3-29 上午11:26:33
  */
public interface IATConstants
{
	public static final String AT_TABLE_NAME_ITEM_GROUP = "IMItemGroup";
	public static final String AT_COLUMN_NAME_ITEM_GROUP_ID = "id";
	public static final String AT_COLUMN_NAME_ITEM_GROUP_DESC = "description";
	
	public static final String AT_TABLE_NAME_DEPARTMENT = "IMDepartment";
	public static final String AT_COLUMN_NAME_DEPARTMENT_ID = "id";
	public static final String AT_COLUMN_NAME_DEPARTMENT_DESC = "description";
	
	public static final String AT_TABLE_NAME_BUSINESS_PARTNER = "IMBusinessPartner";
	public static final String AT_COLUMN_NAME_BUSINESS_PARTNER_CODE = "code";
	public static final String AT_COLUMN_NAME_BUSINESS_PARTNER_NAME = "name";
	public static final String AT_COLUMN_NAME_BUSINESS_PARTNER_TYPE = "type";	
	public static final String AT_COLUMN_NAME_BUSINESS_PARTNER_CLASS1 = "class1";
	public static final String AT_COLUMN_NAME_BUSINESS_PARTNER_CLASS2 = "class2";
	public static final String AT_COLUMN_NAME_BUSINESS_PARTNER_CLASS3 = "class3";
	public static final String AT_COLUMN_NAME_BUSINESS_PARTNER_CLASS4 = "class4";
	public static final String AT_COLUMN_NAME_BUSINESS_PARTNER_CLASS5 = "class5";
	
	public static final String AT_TABLE_NAME_RECIPE = "PMRecipe";
	public static final String AT_COLUMN_NAME_RECIPE_PART_NUMBER = "partNumber";
	public static final String AT_COLUMN_NAME_RECIPE_RAW_WEIGHT = "rawWeight";
	public static final String AT_COLUMN_NAME_RECIPE_ITEM_CODE = "itemCode";	
	public static final String AT_COLUMN_NAME_RECIPE_ITEM_QTY = "itemQty";
	public static final String AT_COLUMN_NAME_RECIPE_SCALE = "scale";
	public static final String AT_COLUMN_NAME_RECIPE_ERROR_RANGE = "errorRange";
	
	/**
	 * 生产计划表
	 * @Nemo
	 */
	String AT_TABLE_PM_WORK_PLAN = "PMWorkPlan";
	String AT_COLUMN_PM_WORK_PLAN_PLANNED_DATE = "planned_date";
	String AT_COLUMN_PM_WORK_PLAN_PRODUCTION_LINE = "production_line";
	String AT_COLUMN_PM_WORK_PLAN_PART_DESCRIPTION = "part_description";	
	String AT_COLUMN_PM_WORK_PLAN_SAP_CODE = "sap_code";
	String AT_COLUMN_PM_WORK_PLAN_PLANNED_QTY = "planned_qty";
	String AT_COLUMN_PM_WORK_PLAN_IS_TEST = "is_test";
	String AT_COLUMN_PM_WORK_PLAN_COMMENT = "comment";
	String AT_COLUMN_PM_WORK_PLAN_IMPORT_DATE = "import_date";
	String AT_COLUMN_PM_WORK_PLAN_IS_ORDERED = "is_ordered";
	String AT_COLUMN_PM_WORK_PLAN_ORDER_NUMBER = "order_number";
	
	/**
	 * 原料拆分方法表
	 * @Nemo
	 */
	String AT_TABLE_PM_MATERIAL_SPLIT_METHOD = "PMMatSplitMethod";
	String AT_COLUMN_PM_MATERIAL_SPLIT_METHOD_DEST_PARTNUMBER = "dest_partNumber";
	String AT_COLUMN_PM_MATERIAL_SPLIT_METHOD_SPLIT_METHOD = "split_method";
	String AT_COLUMN_PM_MATERIAL_SPLIT_METHOD_DOCENTRY = "docEntry";
	
	/**
	 * 原料拆分方法表从表
	 * @Nemo
	 */
	String AT_TABLE_PM_MATERIAL_SPLIT_METHOD_MATERIALS = "PMMatSplitMethodMaterials";
	String AT_COLUMN_PM_MATERIAL_SPLIT_METHOD_MATERIALS_SOURCE_PARTNUMBER = "source_partNumber";

	
	
	/**
	 * 条码规则表
	 * @Nemo
	 */
	String AT_TABLE_IM_BARCODE_RULE = "IMBarcodeRule";
	String AT_COLUMN_IM_BARCODE_RULE_BARCODE_RULE = "barcode_rule";
	String AT_COLUMN_IM_BARCODE_RULE_BARCODE_TYPE = "barcode_type";
	String AT_COLUMN_IM_BARCODE_RULE_TEMPLATE = "template";
	
	/**
	 * 打印记录表
	 * @Nemo
	 */
	String AT_TABLE_IM_PRINT_RECORD = "IMPrintRecord";
	String AT_COLUMN_IM_PRINT_RECORD_BARCODE = "barcode";
	String AT_COLUMN_IM_PRINT_RECORD_BARCODE_TYPE = "barcode_type";
	String AT_COLUMN_IM_PRINT_RECORD_ORDER_NUMBER = "order_name";
	String AT_COLUMN_IM_PRINT_RECORD_PART_DESCRIPTION = "part_description";
	String AT_COLUMN_IM_PRINT_RECORD_PRODUCTION_LINE_NAME = "production_line_name";
	String AT_COLUMN_IM_PRINT_RECORD_RECORD_TYPE = "record_type";
	
	/**
	 * 异物登记表
	 * @Nemo
	 */
	String AT_TABLE_QM_FOREIGN_MATTER = "QMForeignMatter";
	String AT_COLUMN_QM_FOREIGN_MATTER_PROD_BATCH = "prod_batch";
	String AT_COLUMN_QM_FOREIGN_MATTER_PROD_OP = "prod_op";
	String AT_COLUMN_QM_FOREIGN_MATTER_REC_TIME = "rec_time";
	String AT_COLUMN_QM_FOREIGN_MATTER_FOREIGN_MATTER_TYPE = "foreign_matter_type";
	String AT_COLUMN_QM_FOREIGN_MATTER_REC_PEOPLE = "rec_people";
	String AT_COLUMN_QM_FOREIGN_MATTER_HANDLE_MATHOD = "handle_mathod";
	String AT_COLUMN_QM_FOREIGN_MATTER_MARK = "mark";
	String AT_COLUMN_QM_FOREIGN_MATTER_FOREIGN_MATTER_BIG_TYPE = "foreign_matter_big_type";
	String AT_COLUMN_QM_FOREIGN_MATTER_ROUTE_NAME = "route_name";
	String AT_COLUMN_QM_FOREIGN_MATTER_ROUTE_STEP_NAME = "route_step_name";
	String AT_COLUMN_QM_FOREIGN_MATTER_ORDER_NUMBER = "order_number";
	String AT_COLUMN_QM_FOREIGN_MATTER_MATERIAL_NAME = "material_name";
	String AT_COLUMN_QM_FOREIGN_MATTER_SUPPLIER = "supplier";
	String AT_COLUMN_QM_FOREIGN_MATTER_SUPPLIER_NO = "supplier_no";
	String AT_COLUMN_QM_FOREIGN_MATTER_MATTER_QUANTITY = "matter_quantity";
	String AT_COLUMN_QM_FOREIGN_MATTER_MATTER_UOM = "matter_uom";
	
	/**
	 * 添加剂配方表
	 * @Nemo
	 */
	String AT_TABLE_BM_ADDITIVE_PRESCRIPTION = "BMAdditivePrescription";
	String AT_COLUMN_BM_ADDITIVE_PRESCRIPTION_PART_NUMBER = "part_number";
	String AT_COLUMN_BM_ADDITIVE_PRESCRIPTION_PART_DESC = "part_desc";
	String AT_COLUMN_BM_ADDITIVE_PRESCRIPTION_ITEM_CODE = "item_code";
	String AT_COLUMN_BM_ADDITIVE_PRESCRIPTION_ITEM_QTY = "item_qty";
	String AT_COLUMN_BM_ADDITIVE_PRESCRIPTION_SCALE = "scale";
	String AT_COLUMN_BM_ADDITIVE_PRESCRIPTION_ERROR_RANGE = "error_range";
	String AT_COLUMN_BM_ADDITIVE_PRESCRIPTION_ITEM_DESC = "item_desc";
	String AT_COLUMN_BM_ADDITIVE_PRESCRIPTION_STANDARD_WEIGHT = "standard_weight";
	
	/**
	 * 工单消耗表
	 * @Nemo
	 */
	String AT_TABLE_PM_ORDER_CONSUME = "PMOrderConsume";
	String AT_COLUMN_PM_ORDER_CONSUME_BAD_DUST_QTY = "bad_dust_qty";
	String AT_COLUMN_PM_ORDER_CONSUME_CONSUME_QTY = "consume_qty";
	String AT_COLUMN_PM_ORDER_CONSUME_CONSUME_TYPE = "consume_type";
	String AT_COLUMN_PM_ORDER_CONSUME_ORDER_NUMBER = "order_number";
	String AT_COLUMN_PM_ORDER_CONSUME_PART_NUMBER = "part_number";
	String AT_COLUMN_PM_ORDER_CONSUME_SHIFT = "shift";
	String AT_COLUMN_PM_ORDER_CONSUME_UNUSING_QTY = "unusing_qty";
	String AT_COLUMN_PM_ORDER_CONSUME_WAIT_DUST_QTY = "wait_dust_qty";
	
	
	/**
	 * 取样记录表
	 * @Nemo
	 */
	String AT_TABLE_PM_LOCATION = "PMLocation";
	String AT_COLUMN_PM_LOCATION_CARRIER_NAME = "carrier_name";
	String AT_COLUMN_PM_LOCATION_X_LOCATION = "x_location";
	String AT_COLUMN_PM_LOCATION_Y_LOCATION = "y_location";
	
	/**
	 * 原料拆分表
	 * @Nemo
	 */
	String AT_TABLE_PM_MATERIAL_SPLIT = "PMMaterialSplit";
	String AT_COLUMN_PM_MATERIAL_SPLIT_CONSUMED = "consumed";
	String AT_COLUMN_PM_MATERIAL_SPLIT_LOT_NAME = "lot_name";
	String AT_COLUMN_PM_MATERIAL_SPLIT_ORDER_NUMBER = "order_number";
	String AT_COLUMN_PM_MATERIAL_SPLIT_QUANTITY = "quantity";
	String AT_COLUMN_PM_MATERIAL_SPLIT_SCAN_TIME = "scan_time";
}
